Profiling Report for dfTrain

Dataset statistics

Number of variables	18
Number of observations	7500
Missing cells	7580
Missing cells (%)	5.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.7 MiB
Average record size in memory	380.9 B

Variable types

Numeric	12
Categorical	6

Alerts

`Annual Income` is highly overall correlated with `Monthly Debt`	High correlation
`Bankruptcies` is highly overall correlated with `Number of Credit Problems`	High correlation
`Current Credit Balance` is highly overall correlated with `Maximum Open Credit` and 1 other fields	High correlation
`Maximum Open Credit` is highly overall correlated with `Current Credit Balance`	High correlation
`Monthly Debt` is highly overall correlated with `Annual Income` and 1 other fields	High correlation
`Number of Credit Problems` is highly overall correlated with `Bankruptcies`	High correlation
`Bankruptcies` is highly imbalanced (76.9%)	Imbalance
`Purpose` is highly imbalanced (68.0%)	Imbalance
`Annual Income` has 1557 (20.8%) missing values	Missing
`Years in current job` has 371 (4.9%) missing values	Missing
`Months since last delinquent` has 4081 (54.4%) missing values	Missing
`Credit Score` has 1557 (20.8%) missing values	Missing
`Maximum Open Credit` is highly skewed (γ1 = 74.1942154)	Skewed
`Id` is uniformly distributed	Uniform
`Id` has unique values	Unique
`Tax Liens` has 7366 (98.2%) zeros	Zeros
`Number of Credit Problems` has 6469 (86.3%) zeros	Zeros

Reproduction

Analysis started	2025-03-11 22:41:32.355505
Analysis finished	2025-03-11 22:42:51.108532
Duration	1 minute and 18.75 seconds
Software version	ydata-profiling vv4.14.0
Download configuration	config.json

Id
Real number (ℝ)

Uniform Unique

Distinct	7500
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3749.5

Minimum	0
Maximum	7499
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	58.7 KiB

Quantile statistics

Minimum	0
5-th percentile	374.95
Q1	1874.75
median	3749.5
Q3	5624.25
95-th percentile	7124.05
Maximum	7499
Range	7499
Interquartile range (IQR)	3749.5

Descriptive statistics

Standard deviation	2165.2078
Coefficient of variation (CV)	0.57746575
Kurtosis	-1.2
Mean	3749.5
Median Absolute Deviation (MAD)	1875
Skewness	0
Sum	28121250
Variance	4688125
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
4996	1	< 0.1%
5008	1	< 0.1%
5007	1	< 0.1%
5006	1	< 0.1%
5005	1	< 0.1%
5004	1	< 0.1%
5003	1	< 0.1%
5002	1	< 0.1%
5001	1	< 0.1%
Other values (7490)	7490	99.9%

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
7499	1	< 0.1%
7498	1	< 0.1%
7497	1	< 0.1%
7496	1	< 0.1%
7495	1	< 0.1%
7494	1	< 0.1%
7493	1	< 0.1%
7492	1	< 0.1%
7491	1	< 0.1%
7490	1	< 0.1%

Home Ownership
Categorical

Distinct	4
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	481.5 KiB

Home Mortgage	3637
Rent	3204
Own Home	647
Have Mortgage	12

Length

Max length	13
Median length	8
Mean length	8.7238667
Min length	4

Characters and Unicode

Total characters	65429
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Own Home
2nd row	Own Home
3rd row	Home Mortgage
4th row	Own Home
5th row	Rent

Common Values

Value	Count	Frequency (%)
Home Mortgage	3637	48.5%
Rent	3204	42.7%
Own Home	647	8.6%
Have Mortgage	12	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
home	4284	36.3%
mortgage	3649	30.9%
rent	3204	27.2%
own	647	5.5%
have	12	0.1%

Most occurring characters

Value	Count	Frequency (%)
e	11149	17.0%
o	7933	12.1%
g	7298	11.2%
t	6853	10.5%
H	4296	6.6%
	4296	6.6%
m	4284	6.5%
n	3851	5.9%
a	3661	5.6%
M	3649	5.6%
Other values (5)	8159	12.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	65429	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	11149	17.0%
o	7933	12.1%
g	7298	11.2%
t	6853	10.5%
H	4296	6.6%
	4296	6.6%
m	4284	6.5%
n	3851	5.9%
a	3661	5.6%
M	3649	5.6%
Other values (5)	8159	12.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	65429	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	11149	17.0%
o	7933	12.1%
g	7298	11.2%
t	6853	10.5%
H	4296	6.6%
	4296	6.6%
m	4284	6.5%
n	3851	5.9%
a	3661	5.6%
M	3649	5.6%
Other values (5)	8159	12.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	65429	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	11149	17.0%
o	7933	12.1%
g	7298	11.2%
t	6853	10.5%
H	4296	6.6%
	4296	6.6%
m	4284	6.5%
n	3851	5.9%
a	3661	5.6%
M	3649	5.6%
Other values (5)	8159	12.5%

Annual Income
Real number (ℝ)

High correlation Missing

Distinct	5478
Distinct (%)	92.2%
Missing	1557
Missing (%)	20.8%
Infinite	0
Infinite (%)	0.0%
Mean	1366391.7

Minimum	164597
Maximum	10149344
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	58.7 KiB

Quantile statistics

Minimum	164597
5-th percentile	523393
Q1	844341
median	1168386
Q3	1640137
95-th percentile	2820297.3
Maximum	10149344
Range	9984747
Interquartile range (IQR)	795796

Descriptive statistics

Standard deviation	845339.2
Coefficient of variation (CV)	0.61866534
Kurtosis	16.742139
Mean	1366391.7
Median Absolute Deviation (MAD)	380513
Skewness	3.0301716
Sum	8.120466 × 10⁹
Variance	7.1459836 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
969475	4	0.1%
1043651	4	0.1%
1161660	4	0.1%
1058376	4	0.1%
1338113	4	0.1%
939170	3	< 0.1%
1912920	3	< 0.1%
1508600	3	< 0.1%
1405335	3	< 0.1%
2293908	3	< 0.1%
Other values (5468)	5908	78.8%
(Missing)	1557	20.8%

Value	Count	Frequency (%)
164597	1	< 0.1%
175845	1	< 0.1%
177251	1	< 0.1%
191577	1	< 0.1%
192223	1	< 0.1%
194028	1	< 0.1%
199690	1	< 0.1%
201381	1	< 0.1%
206017	1	< 0.1%
216714	1	< 0.1%

Value	Count	Frequency (%)
10149344	1	< 0.1%
9338880	1	< 0.1%
8923844	1	< 0.1%
8758449	1	< 0.1%
8710740	1	< 0.1%
8633790	1	< 0.1%
8200229	1	< 0.1%
7999095	1	< 0.1%
7907382	1	< 0.1%
7883442	1	< 0.1%

Years in current job
Categorical

Missing

Distinct	11
Distinct (%)	0.2%
Missing	371
Missing (%)	4.9%
Memory size	473.5 KiB

10+ years	2332
2 years	705
3 years	620
< 1 year	563
5 years	516
Other values (6)	2393

Length

Max length	9
Median length	7
Mean length	7.6625053
Min length	6

Characters and Unicode

Total characters	54626
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	10+ years
2nd row	8 years
3rd row	6 years
4th row	8 years
5th row	7 years

Common Values

Value	Count	Frequency (%)
10+ years	2332	31.1%
2 years	705	9.4%
3 years	620	8.3%
< 1 year	563	7.5%
5 years	516	6.9%
1 year	504	6.7%
4 years	469	6.3%
6 years	426	5.7%
7 years	396	5.3%
8 years	339	4.5%
(Missing)	371	4.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
years	6062	40.9%
10	2332	15.7%
1	1067	7.2%
year	1067	7.2%
2	705	4.8%
3	620	4.2%
	563	3.8%
5	516	3.5%
4	469	3.2%
6	426	2.9%
Other values (3)	994	6.7%

Most occurring characters

Value	Count	Frequency (%)
	7692	14.1%
y	7129	13.1%
e	7129	13.1%
a	7129	13.1%
r	7129	13.1%
s	6062	11.1%
1	3399	6.2%
0	2332	4.3%
+	2332	4.3%
2	705	1.3%
Other values (8)	3588	6.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	54626	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	7692	14.1%
y	7129	13.1%
e	7129	13.1%
a	7129	13.1%
r	7129	13.1%
s	6062	11.1%
1	3399	6.2%
0	2332	4.3%
+	2332	4.3%
2	705	1.3%
Other values (8)	3588	6.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	54626	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	7692	14.1%
y	7129	13.1%
e	7129	13.1%
a	7129	13.1%
r	7129	13.1%
s	6062	11.1%
1	3399	6.2%
0	2332	4.3%
+	2332	4.3%
2	705	1.3%
Other values (8)	3588	6.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	54626	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	7692	14.1%
y	7129	13.1%
e	7129	13.1%
a	7129	13.1%
r	7129	13.1%
s	6062	11.1%
1	3399	6.2%
0	2332	4.3%
+	2332	4.3%
2	705	1.3%
Other values (8)	3588	6.6%

Tax Liens
Real number (ℝ)

Zeros

Distinct	8
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.030133333

Minimum	0
Maximum	7
Zeros	7366
Zeros (%)	98.2%
Negative	0
Negative (%)	0.0%
Memory size	58.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	7
Range	7
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.27160354
Coefficient of variation (CV)	9.0133919
Kurtosis	215.60457
Mean	0.030133333
Median Absolute Deviation (MAD)	0
Skewness	12.993869
Sum	226
Variance	0.073768485
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
0	7366	98.2%
1	83	1.1%
2	30	0.4%
3	10	0.1%
4	6	0.1%
6	2	< 0.1%
5	2	< 0.1%
7	1	< 0.1%

Value	Count	Frequency (%)
0	7366	98.2%
1	83	1.1%
2	30	0.4%
3	10	0.1%
4	6	0.1%
5	2	< 0.1%
6	2	< 0.1%
7	1	< 0.1%

Value	Count	Frequency (%)
7	1	< 0.1%
6	2	< 0.1%
5	2	< 0.1%
4	6	0.1%
3	10	0.1%
2	30	0.4%
1	83	1.1%
0	7366	98.2%

Number of Open Accounts
Real number (ℝ)

Distinct	39
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.130933

Minimum	2
Maximum	43
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	58.7 KiB

Quantile statistics

Minimum	2
5-th percentile	5
Q1	8
median	10
Q3	14
95-th percentile	20
Maximum	43
Range	41
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	4.9089241
Coefficient of variation (CV)	0.4410164
Kurtosis	2.243359
Mean	11.130933
Median Absolute Deviation (MAD)	3
Skewness	1.1176836
Sum	83482
Variance	24.097536
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=39)

Value	Count	Frequency (%)
9	728	9.7%
11	692	9.2%
10	677	9.0%
8	638	8.5%
7	613	8.2%
12	562	7.5%
6	504	6.7%
13	465	6.2%
14	420	5.6%
5	325	4.3%
Other values (29)	1876	25.0%

Value	Count	Frequency (%)
2	28	0.4%
3	95	1.3%
4	212	2.8%
5	325	4.3%
6	504	6.7%
7	613	8.2%
8	638	8.5%
9	728	9.7%
10	677	9.0%
11	692	9.2%

Value	Count	Frequency (%)
43	1	< 0.1%
42	1	< 0.1%
41	1	< 0.1%
38	1	< 0.1%
37	2	< 0.1%
35	1	< 0.1%
34	2	< 0.1%
33	6	0.1%
32	6	0.1%
31	6	0.1%

Years of Credit History
Real number (ℝ)

Distinct	408
Distinct (%)	5.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.317467

Minimum	4
Maximum	57.7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	58.7 KiB

Quantile statistics

Minimum	4
5-th percentile	9
Q1	13.5
median	17
Q3	21.8
95-th percentile	31.9
Maximum	57.7
Range	53.7
Interquartile range (IQR)	8.3

Descriptive statistics

Standard deviation	7.0419458
Coefficient of variation (CV)	0.38443885
Kurtosis	1.6020707
Mean	18.317467
Median Absolute Deviation (MAD)	4
Skewness	1.0466523
Sum	137381
Variance	49.589
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15	104	1.4%
16	99	1.3%
16.5	91	1.2%
17	86	1.1%
17.5	83	1.1%
14	82	1.1%
18	80	1.1%
15.4	72	1.0%
18.5	72	1.0%
12	70	0.9%
Other values (398)	6661	88.8%

Value	Count	Frequency (%)
4	1	< 0.1%
4.3	1	< 0.1%
4.5	2	< 0.1%
4.7	2	< 0.1%
4.8	4	0.1%
4.9	1	< 0.1%
5	4	0.1%
5.1	4	0.1%
5.2	2	< 0.1%
5.3	1	< 0.1%

Value	Count	Frequency (%)
57.7	1	< 0.1%
52.2	1	< 0.1%
51.9	1	< 0.1%
51.5	1	< 0.1%
51.3	1	< 0.1%
51	1	< 0.1%
50.9	1	< 0.1%
50.6	1	< 0.1%
50	1	< 0.1%
49.1	1	< 0.1%

Maximum Open Credit
Real number (ℝ)

High correlation Skewed

Distinct	6963
Distinct (%)	92.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	945153.73

Minimum	0
Maximum	1.3047262 × 10⁹
Zeros	65
Zeros (%)	0.9%
Negative	0
Negative (%)	0.0%
Memory size	58.7 KiB

Quantile statistics

Minimum	0
5-th percentile	111604.9
Q1	279229.5
median	478159
Q3	793501.5
95-th percentile	1706333.2
Maximum	1.3047262 × 10⁹
Range	1.3047262 × 10⁹
Interquartile range (IQR)	514272

Descriptive statistics

Standard deviation	16026217
Coefficient of variation (CV)	16.956201
Kurtosis	5894.4588
Mean	945153.73
Median Absolute Deviation (MAD)	236060
Skewness	74.194215
Sum	7.088653 × 10⁹
Variance	2.5683962 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	65	0.9%
319110	5	0.1%
246224	3	< 0.1%
344058	3	< 0.1%
513524	3	< 0.1%
615714	3	< 0.1%
607046	3	< 0.1%
358732	3	< 0.1%
443630	3	< 0.1%
594594	3	< 0.1%
Other values (6953)	7406	98.7%

Value	Count	Frequency (%)
0	65	0.9%
4334	1	< 0.1%
6556	1	< 0.1%
6622	1	< 0.1%
10890	1	< 0.1%
10956	1	< 0.1%
11110	1	< 0.1%
11132	1	< 0.1%
11198	1	< 0.1%
12914	1	< 0.1%

Value	Count	Frequency (%)
1304726170	1	< 0.1%
380052288	1	< 0.1%
265512874	1	< 0.1%
57562560	1	< 0.1%
40923894	1	< 0.1%
26406996	1	< 0.1%
26343328	1	< 0.1%
21372428	1	< 0.1%
19280426	1	< 0.1%
18683808	1	< 0.1%

Number of Credit Problems
Real number (ℝ)

High correlation Zeros

Distinct	8
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.17

Minimum	0
Maximum	7
Zeros	6469
Zeros (%)	86.3%
Negative	0
Negative (%)	0.0%
Memory size	58.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	7
Range	7
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.49859785
Coefficient of variation (CV)	2.9329285
Kurtosis	32.101329
Mean	0.17
Median Absolute Deviation (MAD)	0
Skewness	4.5642453
Sum	1275
Variance	0.24859981
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
0	6469	86.3%
1	882	11.8%
2	93	1.2%
3	35	0.5%
4	9	0.1%
5	7	0.1%
6	4	0.1%
7	1	< 0.1%

Value	Count	Frequency (%)
0	6469	86.3%
1	882	11.8%
2	93	1.2%
3	35	0.5%
4	9	0.1%
5	7	0.1%
6	4	0.1%
7	1	< 0.1%

Value	Count	Frequency (%)
7	1	< 0.1%
6	4	0.1%
5	7	0.1%
4	9	0.1%
3	35	0.5%
2	93	1.2%
1	882	11.8%
0	6469	86.3%

Months since last delinquent
Real number (ℝ)

Missing

Distinct	89
Distinct (%)	2.6%
Missing	4081
Missing (%)	54.4%
Infinite	0
Infinite (%)	0.0%
Mean	34.6926

Minimum	0
Maximum	118
Zeros	18
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	58.7 KiB

Quantile statistics

Minimum	0
5-th percentile	5
Q1	16
median	32
Q3	50
95-th percentile	75
Maximum	118
Range	118
Interquartile range (IQR)	34

Descriptive statistics

Standard deviation	21.688806
Coefficient of variation (CV)	0.62517096
Kurtosis	-0.78837222
Mean	34.6926
Median Absolute Deviation (MAD)	16
Skewness	0.43132375
Sum	118614
Variance	470.40431
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14	76	1.0%
29	71	0.9%
8	68	0.9%
33	68	0.9%
19	65	0.9%
13	65	0.9%
12	65	0.9%
6	64	0.9%
7	64	0.9%
10	63	0.8%
Other values (79)	2750	36.7%
(Missing)	4081	54.4%

Value	Count	Frequency (%)
0	18	0.2%
1	26	0.3%
2	25	0.3%
3	30	0.4%
4	31	0.4%
5	51	0.7%
6	64	0.9%
7	64	0.9%
8	68	0.9%
9	61	0.8%

Value	Count	Frequency (%)
118	1	< 0.1%
92	1	< 0.1%
91	1	< 0.1%
86	1	< 0.1%
84	1	< 0.1%
83	3	< 0.1%
82	4	0.1%
81	19	0.3%
80	28	0.4%
79	20	0.3%

Bankruptcies
Categorical

High correlation Imbalance

Distinct	5
Distinct (%)	0.1%
Missing	14
Missing (%)	0.2%
Memory size	439.6 KiB

0.0	6660
1.0	786
2.0	31
3.0	7
4.0	2

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	22458
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	0.0
3rd row	0.0
4th row	1.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	6660	88.8%
1.0	786	10.5%
2.0	31	0.4%
3.0	7	0.1%
4.0	2	< 0.1%
(Missing)	14	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	6660	89.0%
1.0	786	10.5%
2.0	31	0.4%
3.0	7	0.1%
4.0	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	14146	63.0%
.	7486	33.3%
1	786	3.5%
2	31	0.1%
3	7	< 0.1%
4	2	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	22458	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	14146	63.0%
.	7486	33.3%
1	786	3.5%
2	31	0.1%
3	7	< 0.1%
4	2	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	22458	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	14146	63.0%
.	7486	33.3%
1	786	3.5%
2	31	0.1%
3	7	< 0.1%
4	2	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	22458	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	14146	63.0%
.	7486	33.3%
1	786	3.5%
2	31	0.1%
3	7	< 0.1%
4	2	< 0.1%

Purpose
Categorical

Imbalance

Distinct	15
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	537.6 KiB

debt consolidation	5944
other	665
home improvements	412
business loan	129
buy a car	96
Other values (10)	254

Length

Max length	20
Median length	18
Mean length	16.3852
Min length	5

Characters and Unicode

Total characters	122889
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	debt consolidation
2nd row	debt consolidation
3rd row	debt consolidation
4th row	debt consolidation
5th row	debt consolidation

Common Values

Value	Count	Frequency (%)
debt consolidation	5944	79.3%
other	665	8.9%
home improvements	412	5.5%
business loan	129	1.7%
buy a car	96	1.3%
medical bills	71	0.9%
major purchase	40	0.5%
take a trip	37	0.5%
buy house	34	0.5%
small business	26	0.3%
Other values (5)	46	0.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
debt	5944	41.2%
consolidation	5944	41.2%
other	665	4.6%
home	412	2.9%
improvements	412	2.9%
business	155	1.1%
a	133	0.9%
buy	130	0.9%
loan	129	0.9%
car	96	0.7%
Other values (15)	414	2.9%

Most occurring characters

Value	Count	Frequency (%)
o	19553	15.9%
t	13057	10.6%
i	12678	10.3%
n	12642	10.3%
d	11999	9.8%
e	8247	6.7%
s	7012	5.7%
	6934	5.6%
a	6554	5.3%
l	6350	5.2%
Other values (14)	17863	14.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	122889	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	19553	15.9%
t	13057	10.6%
i	12678	10.3%
n	12642	10.3%
d	11999	9.8%
e	8247	6.7%
s	7012	5.7%
	6934	5.6%
a	6554	5.3%
l	6350	5.2%
Other values (14)	17863	14.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	122889	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	19553	15.9%
t	13057	10.6%
i	12678	10.3%
n	12642	10.3%
d	11999	9.8%
e	8247	6.7%
s	7012	5.7%
	6934	5.6%
a	6554	5.3%
l	6350	5.2%
Other values (14)	17863	14.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	122889	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	19553	15.9%
t	13057	10.6%
i	12678	10.3%
n	12642	10.3%
d	11999	9.8%
e	8247	6.7%
s	7012	5.7%
	6934	5.6%
a	6554	5.3%
l	6350	5.2%
Other values (14)	17863	14.5%

Term
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	489.0 KiB

Short Term	5556
Long Term	1944

Length

Max length	10
Median length	10
Mean length	9.7408
Min length	9

Characters and Unicode

Total characters	73056
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Short Term
2nd row	Long Term
3rd row	Short Term
4th row	Short Term
5th row	Short Term

Common Values

Value	Count	Frequency (%)
Short Term	5556	74.1%
Long Term	1944	25.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
term	7500	50.0%
short	5556	37.0%
long	1944	13.0%

Most occurring characters

Value	Count	Frequency (%)
r	13056	17.9%
o	7500	10.3%
	7500	10.3%
T	7500	10.3%
e	7500	10.3%
m	7500	10.3%
S	5556	7.6%
h	5556	7.6%
t	5556	7.6%
L	1944	2.7%
Other values (2)	3888	5.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	73056	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	13056	17.9%
o	7500	10.3%
	7500	10.3%
T	7500	10.3%
e	7500	10.3%
m	7500	10.3%
S	5556	7.6%
h	5556	7.6%
t	5556	7.6%
L	1944	2.7%
Other values (2)	3888	5.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	73056	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	13056	17.9%
o	7500	10.3%
	7500	10.3%
T	7500	10.3%
e	7500	10.3%
m	7500	10.3%
S	5556	7.6%
h	5556	7.6%
t	5556	7.6%
L	1944	2.7%
Other values (2)	3888	5.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	73056	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	13056	17.9%
o	7500	10.3%
	7500	10.3%
T	7500	10.3%
e	7500	10.3%
m	7500	10.3%
S	5556	7.6%
h	5556	7.6%
t	5556	7.6%
L	1944	2.7%
Other values (2)	3888	5.3%

Current Loan Amount
Real number (ℝ)

Distinct	5386
Distinct (%)	71.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11873177

Minimum	11242
Maximum	99999999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	58.7 KiB

Quantile statistics

Minimum	11242
5-th percentile	76186
Q1	180169
median	309573
Q3	519882
95-th percentile	99999999
Maximum	99999999
Range	99988757
Interquartile range (IQR)	339713

Descriptive statistics

Standard deviation	31926123
Coefficient of variation (CV)	2.6889283
Kurtosis	3.7548474
Mean	11873177
Median Absolute Deviation (MAD)	142725
Skewness	2.3986592
Sum	8.9048831 × 10¹⁰
Variance	1.0192773 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
99999999	870	11.6%
218064	6	0.1%
89298	6	0.1%
222926	5	0.1%
265826	5	0.1%
223322	5	0.1%
216106	5	0.1%
270226	5	0.1%
111892	4	0.1%
267982	4	0.1%
Other values (5376)	6585	87.8%

Value	Count	Frequency (%)
11242	1	< 0.1%
21472	2	< 0.1%
21516	1	< 0.1%
21560	1	< 0.1%
21582	1	< 0.1%
21604	1	< 0.1%
21626	1	< 0.1%
21714	1	< 0.1%
21736	1	< 0.1%
21780	1	< 0.1%

Value	Count	Frequency (%)
99999999	870	11.6%
789030	1	< 0.1%
788942	1	< 0.1%
788788	1	< 0.1%
788634	2	< 0.1%
788480	2	< 0.1%
788414	1	< 0.1%
788018	2	< 0.1%
787864	1	< 0.1%
787798	1	< 0.1%

Current Credit Balance
Real number (ℝ)

High correlation

Distinct	6592
Distinct (%)	87.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	289833.24

Minimum	0
Maximum	6506797
Zeros	53
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	58.7 KiB

Quantile statistics

Minimum	0
5-th percentile	29601.05
Q1	114256.5
median	209323
Q3	360406.25
95-th percentile	766593
Maximum	6506797
Range	6506797
Interquartile range (IQR)	246149.75

Descriptive statistics

Standard deviation	317871.38
Coefficient of variation (CV)	1.0967389
Kurtosis	52.946562
Mean	289833.24
Median Absolute Deviation (MAD)	111682
Skewness	5.2013859
Sum	2.1737493 × 10⁹
Variance	1.0104222 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	53	0.7%
191710	5	0.1%
106818	4	0.1%
83638	4	0.1%
136401	4	0.1%
53580	4	0.1%
82289	4	0.1%
155059	4	0.1%
198911	4	0.1%
115482	3	< 0.1%
Other values (6582)	7411	98.8%

Value	Count	Frequency (%)
0	53	0.7%
19	3	< 0.1%
57	2	< 0.1%
76	2	< 0.1%
95	1	< 0.1%
114	1	< 0.1%
171	1	< 0.1%
361	2	< 0.1%
456	1	< 0.1%
494	1	< 0.1%

Value	Count	Frequency (%)
6506797	1	< 0.1%
4720132	1	< 0.1%
4367245	1	< 0.1%
4249673	1	< 0.1%
4209659	1	< 0.1%
3944514	1	< 0.1%
3927471	1	< 0.1%
3683340	1	< 0.1%
3547262	1	< 0.1%
3271629	1	< 0.1%

Monthly Debt
Real number (ℝ)

High correlation

Distinct	6716
Distinct (%)	89.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18314.454

Minimum	0
Maximum	136679
Zeros	6
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	58.7 KiB

Quantile statistics

Minimum	0
5-th percentile	3684
Q1	10067.5
median	16076.5
Q3	23818
95-th percentile	40546.2
Maximum	136679
Range	136679
Interquartile range (IQR)	13750.5

Descriptive statistics

Standard deviation	11926.765
Coefficient of variation (CV)	0.65122141
Kurtosis	5.8328935
Mean	18314.454
Median Absolute Deviation (MAD)	6611.5
Skewness	1.6792352
Sum	1.3735841 × 10⁸
Variance	1.4224772 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6	0.1%
19222	4	0.1%
19667	4	0.1%
12986	3	< 0.1%
13356	3	< 0.1%
14683	3	< 0.1%
10057	3	< 0.1%
11669	3	< 0.1%
25511	3	< 0.1%
10987	3	< 0.1%
Other values (6706)	7465	99.5%

Value	Count	Frequency (%)
0	6	0.1%
17	1	< 0.1%
21	1	< 0.1%
42	1	< 0.1%
57	1	< 0.1%
236	1	< 0.1%
280	1	< 0.1%
284	2	< 0.1%
289	1	< 0.1%
373	1	< 0.1%

Value	Count	Frequency (%)
136679	1	< 0.1%
110311	1	< 0.1%
104036	1	< 0.1%
100091	1	< 0.1%
96177	1	< 0.1%
95508	1	< 0.1%
94674	1	< 0.1%
93640	1	< 0.1%
89789	1	< 0.1%
87994	1	< 0.1%

Credit Score
Real number (ℝ)

Missing

Distinct	268
Distinct (%)	4.5%
Missing	1557
Missing (%)	20.8%
Infinite	0
Infinite (%)	0.0%
Mean	1151.0875

Minimum	585
Maximum	7510
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	58.7 KiB

Quantile statistics

Minimum	585
5-th percentile	666
Q1	711
median	731
Q3	743
95-th percentile	6990
Maximum	7510
Range	6925
Interquartile range (IQR)	32

Descriptive statistics

Standard deviation	1604.4514
Coefficient of variation (CV)	1.393857
Kurtosis	10.063803
Mean	1151.0875
Median Absolute Deviation (MAD)	14
Skewness	3.467217
Sum	6840913
Variance	2574264.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
740	169	2.3%
747	168	2.2%
748	157	2.1%
745	152	2.0%
741	151	2.0%
742	151	2.0%
743	148	2.0%
746	145	1.9%
739	144	1.9%
738	137	1.8%
Other values (258)	4421	58.9%
(Missing)	1557	20.8%

Value	Count	Frequency (%)
585	1	< 0.1%
586	1	< 0.1%
588	1	< 0.1%
589	1	< 0.1%
590	1	< 0.1%
591	1	< 0.1%
593	1	< 0.1%
594	3	< 0.1%
597	2	< 0.1%
598	1	< 0.1%

Value	Count	Frequency (%)
7510	2	< 0.1%
7500	2	< 0.1%
7490	2	< 0.1%
7480	6	0.1%
7470	4	0.1%
7460	8	0.1%
7450	3	< 0.1%
7440	5	0.1%
7430	3	< 0.1%
7420	3	< 0.1%

Credit Default
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	424.9 KiB

0	5387
1	2113

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	7500
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	5387	71.8%
1	2113	28.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	5387	71.8%
1	2113	28.2%

Most occurring characters

Value	Count	Frequency (%)
0	5387	71.8%
1	2113	28.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	7500	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	5387	71.8%
1	2113	28.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	7500	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	5387	71.8%
1	2113	28.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	7500	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	5387	71.8%
1	2113	28.2%

	Annual Income	Bankruptcies	Credit Default	Credit Score	Current Credit Balance	Current Loan Amount	Home Ownership	Id	Maximum Open Credit	Monthly Debt	Months since last delinquent	Number of Credit Problems	Number of Open Accounts	Purpose	Tax Liens	Term	Years in current job	Years of Credit History
Annual Income	1.000	0.016	0.103	0.041	0.396	0.397	0.149	0.008	0.394	0.593	-0.102	-0.048	0.236	0.054	0.048	0.128	0.050	0.257
Bankruptcies	0.016	1.000	0.000	0.000	0.033	0.000	0.000	0.009	0.000	0.019	0.085	0.603	0.000	0.000	0.043	0.026	0.027	0.041
Credit Default	0.103	0.000	1.000	0.445	0.017	0.226	0.063	0.013	0.000	0.000	0.042	0.036	0.000	0.050	0.027	0.181	0.000	0.031
Credit Score	0.041	0.000	0.445	1.000	0.007	-0.032	0.018	-0.008	0.153	-0.062	-0.004	-0.082	-0.020	0.035	-0.024	0.115	0.007	0.061
Current Credit Balance	0.396	0.033	0.017	0.007	1.000	0.370	0.084	-0.017	0.773	0.523	-0.014	-0.209	0.369	0.000	-0.025	0.051	0.034	0.260
Current Loan Amount	0.397	0.000	0.226	-0.032	0.370	1.000	0.009	-0.002	0.361	0.339	-0.021	-0.072	0.179	0.025	0.018	0.076	0.000	0.137
Home Ownership	0.149	0.000	0.063	0.018	0.084	0.009	1.000	0.025	0.143	0.122	0.044	0.000	0.081	0.342	0.000	0.106	0.126	0.130
Id	0.008	0.009	0.013	-0.008	-0.017	-0.002	0.025	1.000	-0.019	0.003	0.009	0.008	0.007	0.000	-0.009	0.000	0.007	-0.005
Maximum Open Credit	0.394	0.000	0.000	0.153	0.773	0.361	0.143	-0.019	1.000	0.427	-0.051	-0.186	0.474	0.072	-0.016	0.000	0.000	0.287
Monthly Debt	0.593	0.019	0.000	-0.062	0.523	0.339	0.122	0.003	0.427	1.000	-0.062	-0.058	0.455	0.039	0.014	0.154	0.044	0.222
Months since last delinquent	-0.102	0.085	0.042	-0.004	-0.014	-0.021	0.044	0.009	-0.051	-0.062	1.000	0.146	-0.039	0.000	0.042	0.000	0.030	-0.026
Number of Credit Problems	-0.048	0.603	0.036	-0.082	-0.209	-0.072	0.000	0.008	-0.186	-0.058	0.146	1.000	-0.010	0.069	0.361	0.015	0.017	0.090
Number of Open Accounts	0.236	0.000	0.000	-0.020	0.369	0.179	0.081	0.007	0.474	0.455	-0.039	-0.010	1.000	0.045	-0.006	0.069	0.020	0.156
Purpose	0.054	0.000	0.050	0.035	0.000	0.025	0.342	0.000	0.072	0.039	0.000	0.069	0.045	1.000	0.042	0.047	0.034	0.027
Tax Liens	0.048	0.043	0.027	-0.024	-0.025	0.018	0.000	-0.009	-0.016	0.014	0.042	0.361	-0.006	0.042	1.000	0.000	0.000	0.022
Term	0.128	0.026	0.181	0.115	0.051	0.076	0.106	0.000	0.000	0.154	0.000	0.015	0.069	0.047	0.000	1.000	0.076	0.080
Years in current job	0.050	0.027	0.000	0.007	0.034	0.000	0.126	0.007	0.000	0.044	0.030	0.017	0.020	0.034	0.000	0.076	1.000	0.095
Years of Credit History	0.257	0.041	0.031	0.061	0.260	0.137	0.130	-0.005	0.287	0.222	-0.026	0.090	0.156	0.027	0.022	0.080	0.095	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	Id	Home Ownership	Annual Income	Years in current job	Number of Open Accounts	Years of Credit History	Maximum Open Credit	Number of Credit Problems	Months since last delinquent	Bankruptcies	Purpose	Term	Current Loan Amount	Current Credit Balance	Monthly Debt	Credit Score	Credit Default
0	0	Own Home	482087.0	NaN	11.0	26.3	685960.0	1.0	NaN	1.0	debt consolidation	Short Term	99999999.0	47386.0	7914.0	749.0	0
1	1	Own Home	1025487.0	10+ years	15.0	15.3	1181730.0	0.0	NaN	0.0	debt consolidation	Long Term	264968.0	394972.0	18373.0	737.0	1
2	2	Home Mortgage	751412.0	8 years	11.0	35.0	1182434.0	0.0	NaN	0.0	debt consolidation	Short Term	99999999.0	308389.0	13651.0	742.0	0
3	3	Own Home	805068.0	6 years	8.0	22.5	147400.0	1.0	NaN	1.0	debt consolidation	Short Term	121396.0	95855.0	11338.0	694.0	0
4	4	Rent	776264.0	8 years	13.0	13.6	385836.0	1.0	NaN	0.0	debt consolidation	Short Term	125840.0	93309.0	7180.0	719.0	0
5	5	Rent	NaN	7 years	12.0	14.6	366784.0	0.0	NaN	0.0	other	Long Term	337304.0	165680.0	18692.0	NaN	1
6	6	Home Mortgage	1511108.0	10+ years	9.0	20.3	388124.0	0.0	73.0	0.0	home improvements	Short Term	99999999.0	51623.0	2317.0	745.0	0
7	7	Rent	1040060.0	10+ years	13.0	12.0	330374.0	0.0	18.0	0.0	other	Short Term	250888.0	89015.0	19761.0	705.0	1
8	8	Home Mortgage	NaN	5 years	17.0	15.7	0.0	1.0	NaN	1.0	home improvements	Short Term	129734.0	19.0	17.0	NaN	0
9	9	Home Mortgage	NaN	1 year	10.0	24.6	511302.0	0.0	6.0	0.0	debt consolidation	Long Term	572880.0	205333.0	17613.0	NaN	1

	Id	Home Ownership	Annual Income	Years in current job	Number of Open Accounts	Years of Credit History	Maximum Open Credit	Months since last delinquent	Purpose	Term	Current Loan Amount	Current Credit Balance	Monthly Debt	Credit Score	Credit Default
7490	7490	Own Home	1368000.0	10+ years	20.0	26.7	897842.0	69.0	debt consolidation	Short Term	683650.0	517199.0	29868.0	688.0	1
7491	7491	Home Mortgage	2833185.0	6 years	18.0	21.3	280170.0	6.0	debt consolidation	Short Term	437404.0	108889.0	61150.0	704.0	0
7492	7492	Home Mortgage	NaN	10+ years	10.0	13.3	423984.0	NaN	debt consolidation	Short Term	332948.0	161481.0	20966.0	NaN	0
7493	7493	Rent	1257610.0	8 years	14.0	16.5	821480.0	58.0	debt consolidation	Long Term	448052.0	167428.0	27562.0	676.0	1
7494	7494	Own Home	NaN	< 1 year	7.0	8.2	301554.0	NaN	debt consolidation	Short Term	290400.0	210938.0	5070.0	NaN	0
7495	7495	Rent	402192.0	< 1 year	3.0	8.5	107866.0	NaN	other	Short Term	129360.0	73492.0	1900.0	697.0	0
7496	7496	Home Mortgage	1533984.0	1 year	10.0	26.5	686312.0	43.0	debt consolidation	Long Term	444048.0	456399.0	12783.0	7410.0	1
7497	7497	Rent	1878910.0	6 years	12.0	32.1	1778920.0	NaN	buy a car	Short Term	99999999.0	477812.0	12479.0	748.0	0
7498	7498	Home Mortgage	NaN	NaN	21.0	26.5	1141250.0	NaN	debt consolidation	Short Term	615274.0	476064.0	37118.0	NaN	0
7499	7499	Rent	NaN	4 years	8.0	9.4	480832.0	NaN	debt consolidation	Short Term	26928.0	288192.0	9061.0	NaN	0

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations